-- insert user with admin role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('DoctorWho4'--<username, varchar(25),>
   ,'TimeLord'--,'' --<password, varchar(25),>
   ,1--<administrator, tinyint,>
   ,1--<staff, tinyint,>
   ,0--<volunteer, tinyint,>
   ,'Tom'--<firstName, varchar(50),>
   ,'Baker' --<lastName, varchar(50),>
   ,'76 Totter''s Lane' --<addressLine1, varchar(50),>
   ,'Shoreditch' --<addressLine2, varchar(50),>
   ,'London' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'53001' --<zipCode, varchar(11),>
   ,'4145551234' --<homePhone, varchar(10),>
   ,'1112229999' --<cellPhone, varchar(10),>
   ,null --<businessPhone, varchar(10),>
   ,'TomBaker@Gallifrey.com' --<emailAddress, varchar(50),>
   ,'http://www.tom-baker.co.uk/dr_who.asp' --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO

-- insert user with staff role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('SaraJane'--<username, varchar(25),>
   ,'companion' --<password, varchar(25),>
   ,0--<administrator, tinyint,>
   ,1--<staff, tinyint,>
   ,0--<volunteer, tinyint,>
   ,'Elisabeth'--<firstName, varchar(50),>
   ,'Sladen' --<lastName, varchar(50),>
   ,'13 Bannerman Road' --<addressLine1, varchar(50),>
   ,'' --<addressLine2, varchar(50),>
   ,'London' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'53002' --<zipCode, varchar(11),>
   ,'2624862655' --<homePhone, varchar(10),>
   ,'1638760094' --<cellPhone, varchar(10),>
   ,'8718467332' --<businessPhone, varchar(10),>
   ,'SarahJaneSmith@DrWho.com' --<emailAddress, varchar(50),>
   ,'http://en.wikipedia.org/wiki/Elisabeth_Sladen' --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO

-- insert user with volunteer role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('Brigadeer'--<username, varchar(25),>
   ,'UNIT' --<password, varchar(25),>
   ,0--<administrator, tinyint,>
   ,0--<staff, tinyint,>
   ,1--<volunteer, tinyint,>
   ,'Nicholas'--<firstName, varchar(50),>
   ,'Courtney' --<lastName, varchar(50),>
   ,'153 Main Street' --<addressLine1, varchar(50),>
   ,'' --<addressLine2, varchar(50),>
   ,'Cambridge' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'51352' --<zipCode, varchar(11),>
   ,'8475921734' --<homePhone, varchar(10),>
   ,'' --<cellPhone, varchar(10),>
   ,'' --<businessPhone, varchar(10),>
   ,'Lethbridge-Stewart@unit.com' --<emailAddress, varchar(50),>
   ,'' --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO

-- insert user with base user role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('joeBob'--<username, varchar(25),>
   ,'visitor1324' --<password, varchar(25),>
   ,0--<administrator, tinyint,>
   ,0--<staff, tinyint,>
   ,0--<volunteer, tinyint,>
   ,'Jon'--<firstName, varchar(50),>
   ,'Jones' --<lastName, varchar(50),>
   ,'122 W. State St' --<addressLine1, varchar(50),>
   ,'' --<addressLine2, varchar(50),>
   ,'Madison' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'56122' --<zipCode, varchar(11),>
   ,null --<homePhone, varchar(10),>
   ,null --<cellPhone, varchar(10),>
   ,null --<businessPhone, varchar(10),>
   ,null --<emailAddress, varchar(50),>
   ,null --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO
